package com.tj.admin.db.dao;
import com.fqgj.common.base.BaseMapper;
import com.tj.admin.db.entity.BizStatsSqlEntity;

import java.util.List;

/**
* User: anonymous
* Date: 2021-11-13
* Time: 19:25:36.589
*/

public interface BizStatsSqlDao  extends BaseMapper<BizStatsSqlEntity> {


    List<Object> executeStatsSql(String sql);

    void createProductCategory(String productCategory, String merchantCode, String appName, String appCode);

    void createMessageChannel(String merchantCode, Integer appId, String linkInfo);


    void createMessageBizCode(String merchantCode, Integer appId);

    void createMessageTemplate(String merchantCode, Integer appId, String appName);

    MsgCommonVo getServicerIdByChannelNameAndAppId(String channelName, Integer appId);

    MsgCommonVo getFunctionIdByBizCodeAndAppId(String bizCode, Integer appId);

    MsgCommonVo getTemplateIdByBizCodeAndAppId(String bizCode, Integer appId);

    void createBusinessRef(Integer appId, Integer servicerId, Integer functionId, Integer templateId);

    void createPayMerchant(String merchantCode, String productCategory);

    void createPayAccount(String merchantCode, String productCategory, int paymentFundCode, int repaymentFundCode);

    void createClStage(String merchantCode);

    List<MsgCommonVo> getAllAppCodes();
}